Question is, how can I only show the User and not the Domain\ ?thanks!

Hi,One way to do this is to manually get the right side of the "\":=iif(InStr(User!UserID,"\") <> 0, Right(User!UserID, Len(User!UserID) - InStr(User!UserID,"\")), User!UserID)Please let me know if anyone has a better solution :-)Hope this helps!Cheers,Lawrence This posting is provided "AS IS" with no warranties, and confers no rights.

I normally use what Lawrence suggested if I want to strip off the Domain name at SSRS level. Or I pass the Domain\Username to the SQL query and then strip off the domain name using SUBSTRING. Effective means to do that is at the Report Server level as it saves CPU cycles for the database engine.This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: http://troubleshootingsql.wordpress.com Twitter: www.twitter.com/banerjeeamit SQL Server FAQ Blog on MSDN: http://blogs.msdn.com/sqlserverfaq

You rock Lawrence! Thanks!

Hi Lawrence, that solution is the only one that worked only this looks "shorter" and does the same thing: = Right(User!UserID, Len(User!UserID) - InStr(User!UserID, "\" )) :)